-- @owner: cr13
-- @date: 2024-10-15
-- @testpoint: 调用函数，传递binary_double_infinity、binary_double_nan作为参数

--step1:打开float_suffix_acceptance参数 expect:成功
set float_suffix_acceptance = on;
show float_suffix_acceptance;

--step2:创建自定义函数 expect:成功
drop function if exists f_fun_0038;
CREATE OR REPLACE FUNCTION f_fun_0038()
RETURNS FLOAT LANGUAGE plpgsql
AS $$
BEGIN
--返回正无穷大
RETURN binary_double_infinity;
END;
$$;
/

--step3:调用自定义函数 expect:成功
SELECT f_fun_0038();

--返回正无穷大

--step4:清理环境 expect:成功
drop function if exists f_fun_0038;


